
USE RD_APMart
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO


USE RD_Common
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE RD_COMMONWORK

exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE RD_ARMart

exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE RD_FixedAssetsMart

exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO


USE RD_GLMart

exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO


USE RD_HRMart
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE RD_InventoryMart
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE RD_ManufacturingMart
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE RD_PayrollMart
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE RD_PurchaseMart
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE RD_SalesMart
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE MicroStrategy_Views
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE RapidReconcilerV5
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO



USE DBA
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO

USE DBmotoRD4
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO


USE RD_WorkOrderMart
exec sp_MSforeachtable @command1=' alter table ? rebuild PARTITION = ALL with (DATA_COMPRESSION = PAGE); print "?";'
GO


